package com.hava.contentsale.dao;

import com.hava.contentsale.meta.UserVO;
import org.apache.ibatis.annotations.Select;

/**
 * Created by zhanpeng on 18/11/2016.
 */
public interface UserVODao {

    @Select("SELECT id,userName AS username,userType AS usertype FROM person WHERE(username = #{param1} AND password = #{param2})")
    public UserVO findByUsername(String username,String password);

    //for test
    @Select("SELECT id,userName AS username,userType AS usertype FROM person WHERE(id = #{param1})")
    public UserVO findOneById(long id);
}